/*
Navicat MySQL Data Transfer

Source Server         : test
Source Server Version : 50516
Source Host           : 192.168.0.7:3306
Source Database       : xinyuan_test

Target Server Type    : MYSQL
Target Server Version : 50516
File Encoding         : 65001

Date: 2017-01-09 01:20:41
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for t_menu
-- ----------------------------
DROP TABLE IF EXISTS `t_menu`;
CREATE TABLE `t_menu` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`position`  varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`parent_id`  int(11) NULL DEFAULT NULL ,
`attributes`  varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=63

;

-- ----------------------------
-- Records of t_menu
-- ----------------------------
BEGIN;
INSERT INTO `t_menu` VALUES ('32', '根节点', '/', null, null), ('33', 'level-1', '/33/', '32', null), ('34', 'level-1-1', '/33/34/', '33', null), ('35', 'level-1-2', '/33/35/', '33', null), ('36', 'level-1-3', '/33/36/', '33', null), ('37', 'level-1-4', '/33/37/', '33', null), ('38', 'level-1-5', '/33/38/', '33', null), ('39', 'level-2', '/39/', '32', null), ('40', 'level-2-1', '/39/40/', '39', null), ('41', 'level-2-2', '/39/41/', '39', null), ('42', 'level-2-3', '/39/42/', '39', null), ('43', 'level-2-4', '/39/43/', '39', null), ('44', 'level-2-5', '/39/44/', '39', null), ('45', 'level-3', '/45/', '32', null), ('46', 'level-3-1', '/45/46/', '45', null), ('47', 'level-3-2', '/45/47/', '45', null), ('48', 'level-3-3', '/45/48/', '45', null), ('49', 'level-3-4', '/45/49/', '45', null), ('50', 'level-3-5', '/45/50/', '45', null), ('51', 'level-4', '/51/', '32', null), ('52', 'level-4-1', '/51/52/', '51', null), ('53', 'level-4-2', '/51/53/', '51', null), ('54', 'level-4-3', '/51/54/', '51', null), ('55', 'level-4-4', '/51/55/', '51', null), ('56', 'level-4-5', '/51/56/', '51', null), ('57', 'level-5', '/57/', '32', null), ('58', 'level-5-1', '/57/58/', '57', null), ('59', 'level-5-2', '/57/59/', '57', null), ('60', 'level-5-3', '/57/60/', '57', null), ('61', 'level-5-4', '/57/61/', '57', null), ('62', 'level-5-5', '/57/62/', '57', null);
COMMIT;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`username`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`password`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=3

;

-- ----------------------------
-- Records of t_user
-- ----------------------------
BEGIN;
INSERT INTO `t_user` VALUES ('1', 'admin', 'admin'), ('2', 'test', 'test');
COMMIT;

-- ----------------------------
-- Table structure for t_user_menu
-- ----------------------------
DROP TABLE IF EXISTS `t_user_menu`;
CREATE TABLE `t_user_menu` (
`u_id`  int(11) NOT NULL ,
`m_id`  int(11) NOT NULL ,
PRIMARY KEY (`u_id`, `m_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of t_user_menu
-- ----------------------------
BEGIN;
INSERT INTO `t_user_menu` VALUES ('1', '34'), ('1', '37'), ('1', '38'), ('2', '36'), ('2', '37'), ('2', '42');
COMMIT;

-- ----------------------------
-- Auto increment value for t_menu
-- ----------------------------
ALTER TABLE `t_menu` AUTO_INCREMENT=63;

-- ----------------------------
-- Auto increment value for t_user
-- ----------------------------
ALTER TABLE `t_user` AUTO_INCREMENT=3;
SET FOREIGN_KEY_CHECKS=1;
